Load data into Power BI desktop and establish table relationships
2
The below screenshots show what to be expected by following the instructions below:


- Download the project data (zip file) by clicking the above Red button.
- Extract data from zip file and save it to your computer. Files include GHG Historical emissions - CSV file, World Population - Excel file, Country Flags - Excel file, Logo - JPEG file and World Map - JSON file.
- Load the 3 of the files (as shown below) into Power BI desk top, one at a time starting with GHG Historical Emission
1. Load GHG Historical emissions data:
As shown in GIF A below
- Click on Get data, select Text/CSV file, click on connect to browse to the location of the file and select GHG Historical emissions file
- Click on TRANSFORM to open power query
- Click on USE FIRST ROWS AS HEADERS above
- Remove the data source and unit columns as they are not needed for the report
GIF A

As shown in GIF B below
- Select all columns and deselect the first 3 columns (Country, Sector, Gas), click on TRANSFROM -> UNPIVOT COLUMNS, this will put all the Year values in one column and all the emissions value in one column
- Right click the Attribute column and change the data type into Date, transform to end of year
- Right click the value column and change the data type into decimal number, right click again and replace the errors with 0, this errors are the N/A values that cannot be represented in decimal number data type
GIF B

As shown in GIF C below
- Rename the attribute column to Date and the Value column to GHG Emissions
- Filter European Union and World in the Country column as these are not countries
- Click close and apply
GIF C

The below screenshot shows what should be expected by following the steps above:

2. Load World population data
- Repeat steps 1 to 4 as shown in GIF A but in step 1, select an Excel file instead, rename the sheet as World Population. In step 4, remove the Indicator name and Indicator code columns.
- Repeat step 1 and 2 as shown in GIF B to unpivot the Year and population columns and rename the attribute columns to Date
- Rename the value column to population. You should have the result below.
- Click on close and apply.

3. Load Country Flags
- Repeat steps 1 to 4 as shown in GIF A but in step 1, select an Excel file instead, rename the sheet as Continent_Country
- Rename the continent name to continent, right click on Country column and click on Index column above
- Rename the index column to Country ID
- Click close and apply
GIF D

4. Establish relationships
Click on Model as shown by the arrow below and a relationship has already been detected for the tables

First, you have to download Power BI Desktop
https://www.microsoft.com/en-us/download/details.aspx?id=58494